Tabela SnomedConcept

Definicja tabeli SnomedConcept

Name

SnomedConcept

Code

SnomedConcept

Comment

Pozycje slownika SNOMED


Lista kolumn tabeli SnomedConcept

Name

Code

ID

ID

EffectiveTime

EffectiveTime

Active

Active

ModuleID

ModuleID

DefinitionStatusID

DefinitionStatusID


Kolumna ID tabeli SnomedConcept

Definicja kolumny ID tabeli SnomedConcept

Name

ID

Code

ID

Data Type

VARCHAR2(18)

Mandatory

Yes

Comment

ID pozycji slownika


Kolumna EffectiveTime tabeli SnomedConcept

Definicja kolumny EffectiveTime tabeli SnomedConcept

Name

EffectiveTime

Code

EffectiveTime

Data Type

DATE

Mandatory

Yes

Comment

Znacznik czasu aktualnosci rekordu


Kolumna Active tabeli SnomedConcept

Definicja kolumny Active tabeli SnomedConcept

Name

Active

Code

Active

Data Type

NUMBER(1)

Mandatory

Yes

Comment

Flaga aktywnosci


Kolumna ModuleID tabeli SnomedConcept

Definicja kolumny ModuleID tabeli SnomedConcept

Name

ModuleID

Code

ModuleID

Data Type

VARCHAR2(18)

Mandatory

Yes

Comment

Identyfikator modulu SNOMED


Kolumna DefinitionStatusID tabeli SnomedConcept

Definicja kolumny DefinitionStatusID tabeli SnomedConcept

Name

DefinitionStatusID

Code

DefinitionStatusID

Data Type

VARCHAR2(18)

Mandatory

Yes

Comment

Status definicji pozycji SNOMED


Lista kluczy tabeli SnomedConcept

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli SnomedConcept

Definicja klucza Identifier_1 tabeli SnomedConcept

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment